SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391802 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391802 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842615,308671,13591,163213,643257,699141,623250,349502,134662,113427,257199,837291,1005038,984479,883173,653773,94796,588759,699105,673511,608112,29311,955819,326005,360223,729316,123850,52394,770739,427549,133508,737570,436304,1003978,99098,839861,545128,823762,606846,109452,640814,979926,813696,801448,39166,932454,880473,813313,893988,966887,807024,18274,689552,287549,380189,837566,114812,905740,302569,275835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003216s ]