SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410119 LIMIT 1 [ RunTime:0.001271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410119 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040007,1039967,852051,941124,414985,11047,49746,863993,494949,397168,226271,722199,578878,456497,59469,236793,355319,709414,946096,912936,711942,262704,725911,130183,681272,26681,742101,142079,524255,1046908,732013,324363,971270,182178,523653,645773,790151,128888,154999,303594,818220,529679,1012042,416928,397732,198674,981031,301806,1016487,436353,2474,80998,823078,930759,765363,891136,790240,657348,671338,478986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004030s ]