SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012463 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012463 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87287,571759,251280,166406,529288,106406,1044393,990170,757158,218766,127348,253301,101289,455775,653651,996829,1028928,524933,525647,427457,166754,406883,355599,815505,346543,328214,595127,637889,754637,415594,633266,60067,832314,639678,574498,332184,222835,821161,329705,935120,507794,713507,129046,946585,364641,741237,741669,72778,626995,423771,656986,757623,123141,462760,663999,4277,300680,547510,831870,343857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]