SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398312 LIMIT 1 [ RunTime:0.000924s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398312 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911963,368053,442167,730913,107781,201926,177328,505922,672423,633981,861328,413979,1010336,168272,461305,240579,604317,250581,156828,311976,988097,377024,294317,855060,768582,983536,219714,348263,283430,331612,868758,64053,799664,254729,114372,256347,636332,452432,834431,793921,722626,496910,1039555,692185,811383,541865,865349,692926,89292,102105,219581,577551,1047276,401866,589910,609260,305701,215383,585745,9744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]