SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022971 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022971 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535173,58061,173919,380414,315478,161713,897794,628193,619012,653061,313231,752050,121122,228264,995045,452030,1035182,327471,502152,69375,864245,253389,301507,770942,671380,574088,79766,855985,641701,935355,939503,837736,1035321,136960,830123,237213,389631,1038256,254411,797886,614086,518374,580275,875306,242179,482475,812608,964389,656311,598779,852372,556802,372877,964843,719338,899740,942051,301493,1045328,631189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]