SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812014 LIMIT 1 [ RunTime:0.004332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812014 [ RunTime:0.004175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59181,387372,705731,355126,256014,98094,817275,535635,1025659,220571,595210,401050,69772,846217,897292,158037,206370,708261,971539,270786,299661,684835,413109,418092,795418,58748,676094,888148,13692,117373,577606,1045368,349977,339099,12375,578022,435215,180412,210353,782277,2279,711198,545233,948844,512655,76618,226540,122180,910466,559308,939646,836176,398136,699514,960238,738798,446901,232802,167247,359084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]