SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814910 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814910 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440008,695986,889843,76023,353434,177087,453346,566946,723114,82179,1022595,851733,271865,119080,341812,482698,919579,729458,755,720330,759060,982938,664166,749235,716586,137573,988818,699207,168109,682834,948024,301973,230613,307212,914341,394987,557810,294313,626059,630166,669715,270104,1013629,229743,956240,761422,305913,899860,95555,338255,546114,737477,531013,92381,285520,790987,593985,172227,686703,165477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]