SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504791 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504791 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471128,741528,63894,294697,492489,786675,244536,636589,723453,590567,780155,302538,223640,285522,235601,951516,764024,502290,555119,755983,856646,685348,667872,668430,630733,144942,129400,808057,130759,164570,617805,750543,914910,1020913,152775,794629,102141,697191,509604,643279,338407,1020868,423345,436257,970178,756341,355907,939475,385698,185117,564212,558534,871305,12622,328725,352670,78276,608201,365321,889918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]