SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5580 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5580 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556628,894659,96359,940403,456908,524459,746804,57916,713610,594737,126055,820805,249541,521306,487322,590237,1037624,825134,82026,599435,570198,284468,719582,289379,818682,579666,60435,927316,958228,691700,822597,486272,431249,288067,892642,286784,723532,927535,10114,787938,441474,1048640,430251,221677,591946,392262,380606,502843,42353,263159,193042,56541,325587,391186,487057,835828,130301,653797,609356,753389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]