SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483903 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483903 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724086,362283,597377,436228,66648,504825,444191,686028,616779,34231,713197,810325,604160,672459,920673,169447,75569,684397,723723,806576,310136,130286,838583,375805,112326,890084,394808,504267,453510,687450,703979,917200,195905,384546,422947,686515,987634,953105,928789,1021895,732641,1018770,756317,720398,463848,543598,607650,689383,455329,412901,882898,192095,123064,897003,254308,938386,151062,260551,384459,630301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]