SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398590 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398590 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393392,933005,625176,634599,335985,384037,960903,449275,1048094,195301,684951,1009573,836699,196038,212586,864406,341332,134816,311751,92149,492113,685786,753451,881974,320051,495641,1047125,102361,439460,1027115,292519,897208,287883,456506,946245,75345,951139,286688,63893,917674,906576,251504,655756,723680,310667,839526,830732,329382,919336,694576,928154,1038014,984020,167031,1030584,1016371,727314,927968,534035,267490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]