SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022943 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022943 [ RunTime:0.003793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714554,665468,1032712,846758,231596,213266,724562,142524,180889,756122,580991,869948,847139,742600,109948,299808,3755,30849,904535,80439,154472,821822,992614,316232,328931,93337,67626,425298,595263,756455,232170,916112,606823,213707,205201,932542,531613,840831,34643,232285,809530,118590,619476,912592,345926,731947,371934,843446,852872,880826,686449,687771,894649,773052,750844,701333,580175,647851,1000961,794791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]