SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513405 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513405 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798012,712191,6431,569226,148408,729530,261599,676450,423096,251274,205186,165795,413838,17441,689090,828825,96341,490471,801549,190632,874287,790188,105812,400689,534393,676691,824317,323613,411863,569521,883448,962020,920123,99477,390673,514281,1045995,253969,524353,993965,363462,686121,992556,726823,37604,220853,891546,627171,154882,499028,116256,208023,81661,450491,651042,631188,643101,834000,896710,683478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]