SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580089 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580089 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684522,333060,592409,981404,513889,420427,906627,917069,718288,418609,13065,167944,781485,180744,766403,743534,684420,698357,733829,689856,876467,610023,186521,171328,133513,722827,851821,282209,207088,182835,979577,820219,816904,24971,225371,761780,161994,151629,91761,526039,119065,861772,565262,546481,506347,96187,621577,866653,243126,896839,408776,99545,440745,279522,846473,329756,813853,905795,9838,47440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]