SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424543 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424543 [ RunTime:0.002740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616612,288528,527120,736704,762946,998047,69611,530311,168524,364906,488493,426045,535494,532772,333385,876327,912959,692480,923084,205968,466,755573,69888,641486,965256,852502,290358,817181,199038,675117,781265,929416,633368,938364,114937,1045995,883857,849259,943574,870243,861011,66844,532460,477978,641331,631736,882221,646614,543933,567594,888271,707666,251170,815739,385300,996363,13354,914315,624621,927975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]