SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539410 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539410 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378498,401883,526974,227525,25181,145367,996830,16176,226677,673018,286446,607784,349854,177149,792007,644785,426888,549207,955744,215778,200076,963524,484823,360703,506981,136208,317781,519367,451109,879717,478081,539094,718621,435708,971455,594473,66862,85590,91901,422553,1023696,998516,890254,835831,833859,989965,895099,297166,77539,813373,927346,672381,560560,831298,343726,713392,866970,839257,489536,420885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]