SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322213 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322213 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63180,153941,165792,284385,664697,1038403,877146,125554,403451,992126,507779,627384,108833,515580,452416,512978,658690,98242,89729,58811,799729,840337,367157,327381,418870,284001,648132,47013,471598,710751,820606,229873,559869,296336,853045,50047,220724,145624,476515,329379,119544,455250,401659,872111,324225,1014281,283088,789888,767320,565769,599794,888241,337710,409743,413161,845182,703093,733863,661986,686997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]