SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029949 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029949 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840464,73622,345653,140404,1006412,938858,1030631,559867,418905,384161,747213,1028519,517677,380809,333605,110447,474751,315474,27116,589407,17854,617713,969047,646588,92816,155492,726117,824377,621300,525735,839185,59182,555699,810982,546494,590441,584316,911168,79536,2953,595192,914204,1033878,890808,449466,169120,447104,824792,738878,403874,979567,756312,1022148,932788,592499,479114,391581,317342,322539,814352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003825s ]