SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519743 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519743 [ RunTime:0.003417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744571,768589,467918,115160,694679,813692,665546,431199,376770,740920,527067,640676,758908,251220,541786,645424,784695,220810,465146,142301,205470,631466,248967,429128,1034098,458782,154230,704012,191336,755609,115776,515188,320479,654252,265244,424081,1043434,762687,435215,815483,1045928,476547,301750,474157,942598,305158,139562,181331,152355,759241,73034,934120,755937,960188,219627,818413,557908,733170,260580,400134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]