SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407687 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407687 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581940,620772,350748,441814,564559,115507,355777,661020,915418,944078,330578,68809,940219,678022,10651,779786,976264,870827,941,155741,978521,560814,195302,108318,397881,943293,103560,174740,343873,638040,114894,874653,57001,461942,657336,364860,237334,216104,902449,161378,347999,876340,714288,850448,75195,923813,843932,322135,573433,831160,338214,835793,979869,178100,93770,71676,371928,125855,168885,987221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]