SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463570 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463570 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80747,905936,28804,1002752,78895,529877,851517,744794,655401,976032,353549,1012431,945233,370505,32330,945763,815180,568358,377378,219889,186509,918246,976252,179133,490992,852869,135160,213356,423344,484104,366,298548,50048,884923,597854,503774,365800,189844,24008,789530,133908,220182,350687,206713,239448,401072,351293,144378,474222,631178,286990,698663,828308,108714,690336,62200,432110,501845,1020547,767759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001733s ]