SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486612 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486612 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531117,1010530,246479,74170,839486,723249,595904,351642,563224,677727,744038,143761,288497,402897,719080,88715,497357,225053,786184,453139,490154,546635,214335,285140,188706,623971,628928,163991,625912,907267,680799,481472,55529,317291,714090,298647,898318,468122,917564,633794,196475,509399,434908,833599,456358,356953,341969,350060,155554,676430,403883,141011,890221,673552,757243,19258,836203,479519,958562,14422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]