SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283102 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283102 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336453,502912,802131,609638,144860,313995,564766,247332,728303,1011574,263271,114343,596087,559977,774516,895143,738348,858165,1010032,402929,688869,504870,373932,293295,290489,937045,117234,996276,815423,299365,675688,707820,832362,537761,957910,642872,135740,113339,607364,168285,789843,877907,375345,450950,960187,242374,695952,681370,788858,832891,866101,138511,785072,491123,601987,403676,1004159,730902,224547,310515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]