SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041717 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041717 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310367,685630,443746,412768,475951,345159,24919,931202,543302,737612,924740,440001,33016,350452,252981,172758,136449,500947,1032632,324873,458648,37035,469875,366448,236265,321640,220311,494698,448722,505710,693039,685467,793715,823485,739191,855769,399398,1023329,147175,214723,893472,219042,595616,678981,740813,565789,847556,878957,25473,405951,142196,681270,896114,178568,1029892,276446,569933,349050,537269,324791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]