SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569018 LIMIT 1 [ RunTime:0.001265s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569018 [ RunTime:0.004262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337969,68337,114826,722437,824493,936327,778127,46139,195420,101794,986250,54789,479858,485282,697473,392608,773279,359886,842102,109424,260132,1047828,124170,546674,296547,726455,925752,188631,928871,625847,473409,304070,452766,723732,485518,298456,214062,652862,945877,917212,950161,353629,270745,737440,540350,179422,809893,501625,632845,518187,136805,120918,952905,891161,970392,933776,137951,281701,548510,1040045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000900s ]