SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50114 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50114 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81054,440917,177217,311565,768298,819670,822390,1024567,550035,561317,71949,828975,322500,86370,355284,381307,173612,283282,165639,564211,1010127,640799,465583,492471,878067,616747,716543,970153,681116,415131,918047,886082,659,841174,83107,537551,1301,914528,28581,837727,68822,973712,1027852,497055,603648,1020619,966132,98131,647373,270365,410126,274885,704948,705201,527058,205232,155654,675820,886597,915832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]