SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028351 LIMIT 1 [ RunTime:0.000673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028351 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24843,260541,660338,675714,197464,213756,82297,827208,915272,812024,9009,711609,699189,674496,119342,739838,292853,62465,846329,388992,768641,817339,583311,182716,811903,731182,923922,202253,119600,831273,538802,33494,563589,407106,150158,412169,695540,752050,215171,960145,296985,892093,464569,490029,9253,748199,671608,485305,546596,143840,854244,400753,695493,378479,70764,504535,841618,890867,740008,115720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]