SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415643 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415643 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891409,344624,1022593,372325,369546,649091,930141,9926,124715,387144,1019801,122643,657950,214583,248350,358008,641823,549815,500006,1011092,352001,764664,1005752,682580,371579,544744,919877,301416,745324,734240,978055,1587,720479,940787,730074,973381,417207,1023104,1035219,596301,193059,78753,16789,825249,636453,1030768,519144,16027,540092,212322,390157,330810,428796,529318,844949,459883,74902,289151,692584,493060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]