SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294091 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294091 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54179,448369,970883,574058,1038755,772099,707098,51872,742199,450070,525253,165447,106068,46715,985344,738161,1048235,187729,277069,516478,736917,176106,313519,379076,169512,636544,834645,217973,774008,248759,762236,826634,93054,165338,801532,366325,632645,848459,124479,319220,542717,352505,555538,622381,902743,809056,227111,265990,549252,461242,993955,97863,785207,108727,339262,225506,667770,84869,80290,345210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]