SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417362 LIMIT 1 [ RunTime:0.000863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417362 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327920,57928,188233,686995,424860,743262,538564,200473,226272,354816,483901,739025,235224,989653,324128,101103,627172,478950,472922,465551,394532,441797,248658,54171,554370,30727,955807,533776,129425,1002973,231225,692989,474145,452751,705730,401000,719619,470958,46141,32802,204723,256504,880612,797208,1022593,1030931,95476,285436,877799,112539,931948,536086,1034219,429681,866589,844316,883438,59907,651033,642814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]