SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532610 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532610 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623261,883468,472982,896644,491505,1031155,256794,752975,1028183,849320,774854,599346,375938,638820,712659,467992,695830,100074,427992,555141,373385,88625,2579,384473,479008,682757,50747,600546,1000679,380049,145478,441901,871013,995846,848420,424718,907843,525866,42795,954166,204353,294598,359362,444870,763194,490461,843959,55863,234588,307051,355139,683629,327476,857515,413554,919201,976752,904099,106307,742372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]