SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536793 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536793 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2445,549519,457836,924136,401728,7606,801629,838585,170204,468737,830885,47561,22561,595314,1026217,470640,710471,871541,244657,334398,657141,446743,381326,261400,1038132,36585,725913,116630,947109,425057,864548,1040130,705252,891412,358323,367173,769845,860442,453433,993841,491914,578760,502530,370665,555206,398468,625204,1045268,556843,495336,795380,409165,649056,131316,291174,909632,597909,533615,287161,100922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]