SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507482 LIMIT 1 [ RunTime:0.004099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507482 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211660,257586,96044,68378,811984,1025567,271969,39200,100142,609045,917663,40283,758559,341433,626532,1005784,390059,406950,636064,478701,724841,431790,127267,83371,350058,633246,1023464,326074,124762,563390,876411,476726,832710,108529,697089,968512,879804,758530,300255,243206,610943,264020,649800,714846,293971,851543,472263,891485,916116,480855,519994,30521,769955,1039122,103425,43938,480730,981898,834788,216444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]