SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151198 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151198 [ RunTime:0.003676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043126,470332,825144,1034903,286940,721901,319300,34030,925805,197952,77423,164366,520871,755154,1020524,682434,675924,626526,794384,826105,984033,916923,203059,692390,48157,37482,259016,490496,474347,837802,295273,335910,316207,403289,919670,289809,43298,324523,708547,199013,228600,488350,681628,597909,158950,358291,933418,420890,10208,811178,483767,236427,43999,584972,53034,801074,716482,329283,911363,692072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]