SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491214 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491214 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745471,796778,385182,342026,58662,146207,389034,66215,719284,178638,438159,478762,734158,905733,888515,684445,651638,1045778,660418,511717,628751,1009315,282418,309417,878163,588568,379808,170649,154304,5850,813320,44453,45280,107426,94920,759577,125288,611807,630016,78087,631352,398355,201790,1020648,713318,480017,950891,1003550,29853,457744,220088,552168,468596,488949,825315,1040597,859001,93707,921674,114194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]