SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420254 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420254 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512589,1018319,339901,598702,509729,627583,966999,755754,883465,327920,245800,972100,856815,906119,293662,864640,750790,470937,348671,492180,630594,831015,706409,366615,145748,206014,948916,502724,553550,812773,621880,960273,1004818,194294,623473,895097,728785,589728,233287,75237,963232,409951,501650,503107,612990,925624,1028530,511023,108873,226562,218395,471465,1040046,265270,462019,74851,108609,1035476,380406,861214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]