SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421007 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421007 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845820,432708,332040,888174,164809,380004,390029,1032769,865850,922162,1004297,933902,681770,678529,176726,271239,200722,624068,871045,36433,201314,668200,1034956,985190,875762,274569,314333,558279,603621,810190,1042153,1006114,665026,10403,920937,272239,517205,826213,71795,481947,287093,137134,625238,354831,305319,396920,194440,467019,653889,817852,167168,608527,915169,170546,689856,722344,744435,482294,506300,174689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]