SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001641s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261058 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261058 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951214,480652,491331,884835,830077,430640,15930,957965,1027199,964886,754947,483276,922826,100199,710639,245632,672729,1040773,231388,88730,554641,204664,729008,653529,531006,223321,994457,424782,593947,739771,62244,935739,79393,230595,307722,699926,750580,702020,1036600,182224,856093,860375,50621,790916,899966,669892,905273,1040168,182478,1039411,308284,855792,104362,943037,143019,810952,606589,463024,286438,478131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]