SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018077 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018077 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245690,219030,369229,87178,37403,522005,281362,810905,375305,113741,766049,303810,987681,315328,337505,479307,568732,702437,308362,566156,812104,864023,444782,887313,465808,322726,474207,165877,702252,974643,376591,632536,185357,224789,741960,663917,733112,882224,349598,1004039,837371,105277,111746,288227,741253,263933,71847,379385,291561,552746,271308,761528,1002984,598607,81545,838612,477641,633047,423901,655212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]