SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141511 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141511 [ RunTime:0.004917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496480,810417,109779,669038,447653,941618,116465,839102,649111,305376,413212,130740,524233,713250,230362,431425,381656,164975,33448,250039,556846,960511,671081,399343,665130,216499,871075,248383,404236,240686,537544,370139,409977,535970,264262,453119,333732,380525,949422,501312,810665,756141,161575,859051,526691,789439,1003491,230139,290051,659282,553341,240441,393539,85657,21334,890384,709437,408336,402067,36095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]