SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508173 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508173 [ RunTime:0.003360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043280,908693,198754,624782,916626,368052,138686,804704,456379,262705,495128,883870,422119,204651,879077,904419,140690,71684,682433,589520,906382,492200,596888,201874,778738,715038,142887,825369,771670,474070,853221,875337,558936,280252,591204,901017,146732,453468,1017599,703690,580943,632742,786133,929324,667198,89343,384463,797221,306284,653547,15691,92921,601953,451229,999897,568236,260062,889740,837799,164611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]