SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56589 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56589 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414217,753217,137345,718135,9361,252843,907265,43413,381030,1014718,899332,292289,872714,477804,949375,725183,735065,514976,225834,146694,1031924,575009,660931,473238,1014971,530644,713163,1017118,506179,660423,243437,655634,535521,809330,250000,833920,1028764,1010144,42768,983062,413272,374714,13204,501737,590110,399959,125883,940777,241053,959108,937423,312724,896266,136449,10492,502242,860907,420926,184241,768707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]