SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040403 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040403 [ RunTime:0.002379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395123,75554,73527,634860,583737,57663,433872,610565,432661,176631,396868,128006,848242,62543,625705,863766,265135,923619,74009,75685,635169,239332,4522,1045839,71468,840733,845565,580082,1001051,39633,967326,1029860,711951,169288,111083,683300,138318,131945,605137,657082,412881,528347,427728,657994,617779,913853,473611,138306,674952,359001,988320,971672,938600,619457,361551,51925,438981,565916,537128,627012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]