SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047974 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047974 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334729,983448,46400,393161,880509,418436,140700,472521,677603,170924,977677,771353,212100,414894,882749,98402,639976,748558,151871,28620,666601,61200,804266,624187,787074,1037332,184479,444701,839587,676325,527225,53346,644884,436050,941566,899700,308903,808177,34796,372290,113023,543309,240022,825549,354977,534430,139659,341844,23885,832191,687892,635194,319193,132418,958900,610040,1028456,1019933,453879,133634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]