SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020702 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020702 [ RunTime:0.005436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959932,322716,503912,856203,1008680,426071,399516,474496,622140,621216,927190,453658,136235,853578,725170,92000,587508,348842,858864,837221,361894,814727,825403,740714,699732,64105,676238,264178,71447,572475,876836,7452,249542,791275,970676,384519,585236,31120,208922,284009,386147,143456,959920,927959,75698,590899,57858,596180,335782,282375,411823,214318,801180,7516,725087,197060,642101,249104,246812,586986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]