SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111373 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111373 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411650,243786,926853,601078,491264,311119,892280,19900,919436,862433,276732,482886,1015031,1036777,748364,65034,535525,618591,931869,169585,431371,925830,653646,323309,439273,101915,512449,710288,304698,197799,1038222,75982,137548,229126,645684,282447,36102,583901,553371,563968,570219,943436,626907,6538,913728,403950,947916,634567,719269,978705,434340,13000,581550,482747,975365,466546,233331,698824,878375,8179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]