SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544933 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544933 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200427,530324,967580,104215,345700,221572,13015,648170,526256,655914,685181,512703,492987,201188,294022,327277,113337,1034462,563749,199423,850345,161620,763889,164894,282779,655665,71298,514495,244898,346351,922389,312649,594751,31195,106269,777271,192359,1027277,495445,974336,792637,465441,214591,288790,981441,563857,607228,902185,597234,283931,845110,685217,114473,82345,973912,480753,750941,174942,992398,613133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002835s ]