SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 748098 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 748098 [ RunTime:0.002390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180685,865656,510931,278474,518169,458743,588280,490075,377554,814452,903228,568141,238076,128349,117977,408276,646953,226247,1024286,795798,917835,618225,981915,855171,152575,798806,559324,283860,700428,725756,144923,149921,479817,420752,243548,1034981,362042,574703,899029,379353,112640,97091,399071,363278,623266,100147,1036457,664697,485465,340139,353243,756913,208343,945672,1040500,436303,567509,302941,507993,782547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 748098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 748098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]