SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30518 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30518 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702612,109188,132646,817791,863372,621728,308831,996494,286213,365221,112295,455969,886799,504737,430164,779056,129798,1044232,330888,344928,402235,1006220,42533,576208,401555,460654,336304,430783,658903,6805,1047813,182868,536385,16942,930767,478223,431251,880519,992446,862264,852168,758350,193837,586787,754162,626705,807701,97272,763560,790024,295249,480378,32203,572616,1017125,836727,784863,27995,568613,729466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]