SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342096 LIMIT 1 [ RunTime:0.000898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342096 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480942,230096,582198,20355,40075,845568,915383,981788,240929,393876,763034,566146,148531,696026,593597,441176,439019,630165,584829,600673,343485,785999,30512,620132,955617,264382,581074,147656,721100,669870,927184,380015,927255,222853,748394,663586,22362,622854,469963,411753,549695,227976,108536,360321,809611,271059,60206,222620,238984,340309,829618,254437,105088,422846,433023,56531,120769,95451,216694,870869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001049s ]