SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029138 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029138 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480074,542092,396770,521204,832947,204664,403158,358854,48122,391111,235738,700210,136078,142031,616821,843819,275405,922543,478280,320021,445694,837921,118113,935731,635747,671848,689432,431898,95034,298491,454727,420210,638383,109445,718682,779021,455916,65023,303235,697813,21451,60991,132520,133063,821670,506258,395601,826298,417892,578192,512028,455359,821179,174723,714974,806123,51704,282930,272749,285755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001014s ]