SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571310 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571310 [ RunTime:0.001396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512174,739752,933087,410558,528791,888695,481607,978199,317538,285806,585955,288799,44865,1017401,330880,586915,679325,437034,798635,49440,719399,608995,762991,135398,607491,390394,300205,59706,347153,548705,530284,345579,160181,490507,986882,252250,148645,20362,969515,206198,481179,396405,874230,938352,604819,866358,603003,286053,234559,465820,200366,373257,62300,498531,218701,322568,652347,433630,407777,771953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]