SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418945 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418945 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193338,961620,910964,69562,745612,625752,893940,81719,1003126,307977,796315,935007,601082,798047,650843,79725,328070,600365,29305,683388,622566,218972,396077,584378,816175,386903,360387,422373,428665,466185,110409,1023469,849789,512842,600179,693868,236791,474317,429312,147650,604870,78349,837603,351298,1016248,363040,99655,1017939,831253,723957,977772,777856,430021,568950,98732,439045,91215,712493,703638,798134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002514s ]