SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681119 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681119 [ RunTime:0.003999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99679,799068,158547,47737,733895,329679,107948,515547,362088,630927,708640,163230,1018021,708504,274094,289538,420871,1000309,162599,912431,559042,715542,240831,463473,410896,531672,890218,489234,546507,514935,109944,419673,545434,740445,505551,267764,404165,51816,371445,388274,365025,874605,140764,402595,795489,385731,124583,326328,600368,909421,108510,715752,295018,371985,575628,69339,408259,612836,522666,1037610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001456s ]