SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 728048 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 728048 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512400,601336,972720,174645,595377,855052,884070,231534,960062,101150,594818,67085,1032845,695464,75459,321018,784086,197886,56810,976818,94010,895604,1041815,519082,129971,815931,46926,702576,509246,682151,482904,733117,762869,1014655,239891,1008464,1041925,959983,262693,820990,931421,983338,185345,109569,85228,757547,228486,1013048,370989,37660,161475,84659,23237,880898,570508,825264,298731,376938,334489,621001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 728048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 728048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]