SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504455 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504455 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296186,401410,443669,782060,169022,446624,448834,406924,3929,617275,565739,493416,984875,321703,1022224,304360,1032652,142876,716442,253850,578479,12479,685713,843801,395308,425256,612341,984044,869726,20221,894022,2389,337475,932645,612985,224257,228703,529226,667997,79642,187200,979847,257034,722552,457633,707775,695023,231535,358311,857527,1002638,774373,98078,741002,63292,68923,736029,711957,334425,449147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]