SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048771 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048771 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914766,454660,106844,76682,391357,1009157,797529,294120,856937,665059,274851,771867,361042,753890,969318,652112,419708,339263,1018764,927919,589968,8974,647164,474030,305509,325295,451614,275974,607109,774484,117119,1004211,370562,919036,1020862,1020132,768425,205059,407444,495190,882879,717595,413483,762188,456758,245529,308247,928440,453744,343568,708553,1008235,208830,9991,172188,975447,223242,786420,489145,921818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]