SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412327 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412327 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519377,311984,333941,531017,25136,681938,934281,924115,452582,177713,263957,731470,909806,87743,638025,995701,380837,343441,164268,219426,565004,395565,634454,173455,170784,311934,419068,577158,476309,780277,83382,704857,952152,1045054,41564,522093,17332,137857,891524,1007268,329899,31025,235546,255631,435311,11578,752574,809162,948520,132181,347950,62137,9623,30747,364450,144026,374550,520436,444883,192715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001192s ]