SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102080 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102080 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554055,557878,594978,569369,84590,926216,846862,774761,94752,816260,834660,533213,806607,933622,277475,790343,982556,79258,151297,817634,921445,502433,860036,60281,589348,788345,525629,1000202,330759,197295,778773,408514,314314,949330,461256,36365,1019500,774660,1010583,528461,947103,889097,773385,957111,704454,1028200,646209,18792,853881,752989,91902,472747,930484,959567,619282,562707,2355,454467,583165,63477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]