SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 823813 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 823813 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612873,46231,972000,121674,28898,741836,929503,869686,109785,8843,524576,509603,514866,680588,329908,945978,564076,234643,461421,860648,105970,796820,445698,4386,304412,965981,486014,108245,888940,611897,1028215,379597,170732,264880,858633,656832,121707,543500,540439,721562,509499,195169,382083,512336,48747,355447,400150,160893,4725,395750,394270,465796,801387,149770,576136,929514,794339,318340,658959,736806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 823813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 823813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]