SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499509 LIMIT 1 [ RunTime:0.005249s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499509 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688037,673773,731373,460815,676224,592439,86493,559038,23127,1030423,265261,853416,577385,1021231,271650,860417,78838,714452,968433,720650,331194,816337,950728,177662,4416,771449,496669,298321,28978,748754,640989,570983,243207,209470,625180,127984,982354,595124,982970,1000377,27335,871564,62112,477489,812647,86702,782033,952747,368236,869873,191768,418324,486482,470611,57543,992053,177648,319068,906758,944750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002285s ]