SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28671 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28671 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032130,314961,876636,557135,123970,561571,464722,812666,525000,814742,60938,32480,699464,225386,734734,76161,456322,60249,245065,630777,521485,211381,197379,103880,372364,545328,717806,630956,147861,626218,448587,764089,4124,564765,367684,370613,501303,983195,592747,41487,109888,337041,819724,680214,666767,230331,816163,321129,987879,673979,983099,174231,813109,777136,537310,789943,933889,737844,70267,334807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001029s ]