SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56838 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56838 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6447,409278,83580,46820,751104,973519,697245,562280,959656,1035568,687072,693424,976640,889755,836619,392532,984923,999125,526576,13414,500458,481724,136503,974764,291704,383739,122270,60032,402983,68675,440554,148339,783116,817554,357408,1035264,477101,796809,11549,481051,940245,206732,633875,227582,825561,987127,1036174,951344,801476,124005,274262,921318,742736,896077,629824,767798,246590,451408,976977,966342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]