SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41993 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41993 [ RunTime:0.003132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985690,205697,118068,334065,430053,172572,79137,870925,578819,178277,325999,10483,975672,829066,889473,788375,806639,567325,705636,258696,309546,186202,790922,720929,878513,336474,485820,592331,367065,300544,601249,551687,449992,866629,980538,1004875,112861,814136,277091,718581,145824,597011,260185,242760,394607,338529,30415,446703,938431,810386,951272,831185,242038,297924,384549,992981,330439,767087,655605,711847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]