SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406099 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406099 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237789,652232,884550,956345,330835,811845,519367,531930,560008,365004,701774,579995,856593,408282,273697,237364,125174,43908,374823,945051,469650,1024691,363994,763679,909157,878606,649291,538152,26407,973934,307408,1041910,426804,466225,251158,589245,830368,519261,751293,750287,657550,1008462,6619,176044,895514,1035024,322594,755212,878408,926914,664396,250110,734949,983698,392663,942700,101876,1046862,180257,126689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]