SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 832012 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 832012 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805092,617663,643708,302528,537741,429026,624693,351459,104661,876460,794523,824937,396534,525353,520290,28938,750524,543096,714015,684466,696761,561555,400089,689762,1000323,902689,599885,599368,809960,116129,415662,556779,1004438,634002,210633,393914,736302,340022,36373,128548,881732,622335,415309,728138,497695,665415,976605,992291,89189,472742,768406,1032577,872835,228144,383953,973956,919128,788722,757427,92305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 832012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 832012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]