SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405152 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405152 [ RunTime:0.003272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414155,305843,773905,16756,351090,555099,479485,616643,1041553,799300,519405,720913,367676,457521,183132,742504,710668,375376,752223,520659,261736,948430,379932,143017,462260,108831,249271,600064,143585,469535,246125,420298,250509,443434,338737,725737,901275,777047,65376,690326,700086,516535,920195,481136,1025055,37216,945364,702621,193657,524790,391677,788364,8622,163815,128665,975463,767212,364744,843408,710707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]