SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547194 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547194 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159087,105087,720667,786782,685709,907398,589855,688973,780681,835830,941293,1023758,1009833,843275,297471,18623,509022,172711,108251,485145,445445,1040311,184505,542999,788672,301867,755901,586636,364762,850076,385299,926509,458774,276786,780666,664147,398302,109517,1046765,871738,529726,239045,424365,522289,330518,102699,890916,267886,1040454,259835,72352,402941,803484,670317,958842,291075,891820,541082,916488,518330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]