SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40572 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40572 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615914,216422,124377,989823,877858,442529,482790,434300,269296,447184,141103,932719,444611,127044,639090,905513,475009,55308,389743,669113,734868,567977,294659,507512,51428,863130,2547,998768,93363,915083,220358,418676,478577,399615,797628,441524,697363,577288,304905,768193,438599,66446,824798,566481,217911,633934,552848,870181,819680,899806,638291,862537,858720,654740,700240,424119,617643,746145,115799,555442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]