SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781713 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781713 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008220,822705,149828,347469,212334,69725,912068,860296,614136,608168,753805,862243,603672,915678,1042327,910365,484106,618875,1001427,488849,260660,652673,989976,56742,402311,604387,820925,140198,817681,855273,171728,455552,203343,840667,812430,1031019,859339,1017468,152315,143507,522417,128433,644406,516173,183482,561516,613343,17340,1006990,574199,1024234,232117,788647,907555,295122,191271,1031167,5674,631094,325823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]